Problem Note 39317: Invalid treatment surrogate keys are created when using Copy and Paste commands to create treatments in the SAS® Management Console Folders pane
 |  |  |  |
The treatment surrogate keys are incorrect in the SAS® Customer Intelligence Reporting Common Data Model. The values are divided by 1000.
In the SAS Management Console Folders pane under SAS Folders ► Products ► SAS Customer Intelligence ► [Business Context name] ► [Treatments Folder], it is possible to create new treatments using the Copy and Paste commands. When the treatment is subsequently used in a campaign, invalid treatment surrogate keys will be created in the Reporting Common Data Model. This will cause data integrity problems within the Common Data Model and any reports that are written against it. You might also see constraint vioaltion errors when publishing campaigns due to duplicate surrogate keys.
The only way to fix this problem if it happens is to manually rebuild the surrogate keys in the database, which is time consuming and difficult. Should this happen please contact SAS Technical Support for assistance.
To work around this problem, use the duplicate treatment functionality that is available in the SAS Customer Intelligence Studio Treatments Dialog (select View ► Treatments) instead of using the Copy and Paste commands in SAS Management Console.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Customer Intelligence Plug-ins for SAS Management Console | Microsoft® Windows® for x64 | 5.3 | 5.3_M3 | 9.2 TS2M2 | 9.2 TS2M3 |
| Microsoft Windows Server 2003 Datacenter Edition | 5.3 | 5.3_M3 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 5.3 | 5.3_M3 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Standard Edition | 5.3 | 5.3_M3 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2008 | 5.3 | 5.3_M3 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Microsoft Windows XP Professional | 5.3 | 5.3_M3 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Windows 7 Enterprise 32 bit | 5.3 | 5.3_M3 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Windows 7 Enterprise x64 | 5.3 | 5.3_M3 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Windows 7 Home Premium 32 bit | 5.3 | 5.3_M3 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Windows 7 Home Premium x64 | 5.3 | 5.3_M3 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Windows 7 Professional 32 bit | 5.3 | 5.3_M3 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Windows 7 Professional x64 | 5.3 | 5.3_M3 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Windows 7 Ultimate 32 bit | 5.3 | 5.3_M3 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Windows 7 Ultimate x64 | 5.3 | 5.3_M3 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Windows Vista | 5.3 | 5.3_M3 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| 64-bit Enabled AIX | 5.3 | 5.3_M3 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| 64-bit Enabled Solaris | 5.3 | 5.3_M3 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| HP-UX IPF | 5.3 | 5.3_M3 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Linux for x64 | 5.3 | 5.3_M3 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Solaris for x64 | 5.3 | 5.3_M3 | 9.2 TS2M2 | 9.2 TS2M3 | ||